{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["System Requirements","Metrics","Stakeholders","Notes","Acronyms"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"System Requirements","index":0,"n_rows":92,"n_cols":38,"rows_kept":92,"cut":false,"hidden":false,"merged":[]}
["System Requirements","Actual","%",null,null,"Color Codes","Component 1",{"$f":"COUNTIFS(E9:E314, G1, D9:D314, \"W\")","v":27},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SYS Tag","Req Start"]
["Total Valid",{"$f":"COUNTIF(C9:C314, \"V\")","v":69},null,null,null,null,"Component 2",{"$f":"COUNTIFS(E9:E314, G2, D9:D314, \"W\")","v":23},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SYS",1]
["Completed",{"$f":"COUNTIF(D9:D314, \"Y\")","v":0},{"$f":"COUNTIF(D9:D314,\"Y\")/COUNTIF(C9:C314,\"V\")","v":0},null,null,null,"Component 3",{"$f":"COUNTIFS(E9:E314, G3, D9:D314, \"W\")","v":8},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SYS",1]
["Uncompleted",{"$f":"COUNTIF(D9:D314, \"W\")","v":82},{"$f":"COUNTIF(D9:D314,\"W\")/COUNTIF(C9:C314,\"V\")","v":1.1884057971014492},null,null,null,"Component 4",{"$f":"COUNTIFS(E9:E314, G4, D9:D314, \"W\")","v":9}]
["Deferred",{"$f":"COUNTIFS(D9:D314, \"D\", C9:C314, \"V\")","v":0},{"$f":"COUNTIF(D9:D314,\"D\")/COUNTIF(C9:C314,\"V\")","v":0},null,"Total In-Work Hours",{"$f":"SUMIF(D9:D314,\"W\",I9:I314)","v":0},"Component 4",{"$f":"COUNTIFS(E10:E315, G5, D10:D315, \"W\")","v":9}]
["Removed",{"$f":"COUNTIF(D9:D314, \"R\")","v":2},null,null,"Business Days",{"$f":"SUMIF(D9:D314,\"W\", I9:I314)/8","v":0},"Average Hours Per In-Work Requirement",{"$f":"IF($B$4=0, \"0\", $F$5/$B$4)","v":0}]
[]
["Requirements","Req#","Work","Reviewed\nStatus","Component","Type","Scenario","Fixed Version","Effort Level","Date Completed","Class","Type","Pedigree","Demonstration","Examination","Trace From","Trace To"]
[null,{"$f":"CONCATENATE($AK$2, ROW()-8)","v":"SYS1"},"V","W","Component 1",null,null,null,0,null,"Functional"]
[null,{"$f":"CONCATENATE($AK$2, ROW()-8)","v":"SYS2"},"V","W","Component 1",null,null,null,0,null,"Functional"]
[null,"SYS3","V","W","Component 1",null,null,null,0,null,"Functional"]
[null,"SYS4","V","W","Component 1",null,null,null,0,null,"Functional"]
[null,"SYS5","V","W","Component 1",null,null,null,0,null,"Functional"]
[null,"SYS6","V","W","Component 1",null,null,null,0,null,"Functional"]
[null,"SYS7","V","W","Component 1",null,null,null,0,null,"Functional"]
[null,"SYS8","V","W","Component 1",null,null,null,0,null,"Functional"]
[null,"SYS9","V","W","Component 1",null,null,null,0,null,"Functional"]
[null,"SYS10","V","W","Component 1",null,null,null,0,null,"Functional"]
[null,"SYS11","V","W","Component 1",null,null,null,0,null,"Functional"]
[null,"SYS12","V","W","Component 1",null,null,null,0,null,"Functional"]
[null,"SYS13","V","W","Component 1",null,null,null,0,null,"Functional"]
[null,"SYS14","V","W","Component 1",null,null,null,0,null,"Functional"]
[null,"SYS15","V","W","Component 1",null,null,null,0,null,"Functional"]
[null,"SYS16","V","W","Component 1",null,null,null,0,null,"Functional"]
[null,"SYS17","V","W","Component 1",null,null,null,0,null,"Functional"]
[null,"SYS18","V","R","Component 1",null,null,null,0,null,"Functional"]
[null,"SYS19","V","R","Component 1",null,null,null,0,null,"Functional"]
[null,"SYS20","V","W","Component 1",null,null,null,0,null,"Functional"]
[null,"SYS21","V","W","Component 1",null,null,null,0,null,"Functional"]
[null,"SYS22","V","W","Component 1",null,null,null,0,null,"Functional"]
[null,"SYS23","V","W","Component 1",null,null,null,0,null,"Functional"]
[null,"SYS24","V","W","Component 1",null,null,null,0,null,"Functional"]
[null,"SYS25","V","W","Component 1",null,null,null,0,null,"Functional"]
[null,"SYS26","V","W","Component 1",null,null,null,0,null,"Functional"]
[null,"SYS27","V","W","Component 1",null,null,null,0,null,"Functional"]
[null,"SYS28","V","W","Component 1",null,null,null,0,null,"Functional"]
[null,"SYS29","V","W","Component 1",null,null,null,0,null,"Functional"]
[null,"SYS30","V","W","Component 2",null,null,null,0,null,"Functional"]
[null,"SYS31","V","W","Component 2",null,null,null,0,null,"Functional"]
[null,"SYS32","V","W","Component 2",null,null,null,0,null,"Functional"]
[null,"SYS33","V","W","Component 2",null,null,null,0,null,"Functional"]
[null,"SYS34","V","W","Component 2",null,null,null,0,null,"Functional"]
[null,"SYS35","V","W","Component 2",null,null,null,0,null,"Functional"]
[null,"SYS36","V","W","Component 2",null,null,null,0,null,"Functional"]
[null,"SYS37","V","W","Component 2",null,null,null,0,null,"Functional"]
[null,"SYS38","V","W","Component 2",null,null,null,0,null,"Functional"]
[null,"SYS39","V","W","Component 2",null,null,null,0,null,"Functional"]
[null,"SYS40","V","W","Component 2",null,null,null,0,null,"Functional"]
[null,"SYS41","V","W","Component 2",null,null,null,0,null,"Functional"]
[null,"SYS42","V","W","Component 2",null,null,null,0,null,"Functional"]
[null,"SYS43","V","W","Component 2",null,null,null,0,null,"Functional"]
[null,"SYS44","V","W","Component 2",null,null,null,0,null,"Functional"]
[null,"SYS45","V","W","Component 2",null,null,null,0,null,"Functional"]
[null,"SYS46","V","W","Component 2",null,null,null,0,null,"Functional"]
[null,"SYS47","V","W","Component 2",null,null,null,0,null,"Quality"]
[null,"SYS48","V","W","Component 2",null,null,null,0,null,"Quality"]
[null,"SYS49","V","W","Component 2",null,null,null,0,null,"Quality"]
[null,"SYS50","V","W","Component 2",null,null,null,0,null,"Quality"]
[null,"SYS51","V","W","Component 2",null,null,null,0,null,"Quality"]
[null,"SYS52","V","W","Component 2",null,null,null,0,null,"Quality"]
[null,"SYS53","V","W","Component 3",null,null,null,0,null,"Quality"]
[null,"SYS54","V","W","Component 3",null,null,null,0,null,"Quality"]
[null,"SYS55","V","W","Component 3",null,null,null,0,null,"Quality"]
[null,"SYS56","V","W","Component 3",null,null,null,0,null,"Quality"]
[null,"SYS57","V","W","Component 3",null,null,null,0,null,"Quality"]
[null,"SYS58","V","W","Component 3",null,null,null,0,null,"Quality"]
[null,"SYS59","V","W","Component 3",null,null,null,0,null,"Quality"]
[null,"SYS60","V","W","Component 3",null,null,null,0,null,"Quality"]
[null,"SYS61","V","W","Component 4",null,null,null,0,null,"Quality"]
[null,"SYS62","V","W","Component 4",null,null,null,0,null,"Quality"]
[null,"SYS63","V","W","Component 4",null,null,null,0,null,"Quality"]
[null,"SYS64","V","W","Component 4",null,null,null,0,null,"Functional"]
[null,"SYS65","V","W","Component 4",null,null,null,0,null,"Functional"]
[null,"SYS66","V","W","Component 4",null,null,null,0,null,"Functional"]
[null,"SYS67","V","W","Component 4",null,null,null,0,null,"Functional"]
[null,{"$f":"CONCATENATE($AK$2, ROW()-8)","v":"SYS68"},"V","W","Component 4",null,null,null,0,null,"Functional"]
[null,"SYS69","V","W","Component 4",null,null,null,0,null,"Functional"]
[null,"SYS70","I","W",null,null,null,null,0,null,"Functional"]
[null,"SYS71","I","W",null,null,null,null,0,null,"Functional"]
[null,"SYS72","I","W",null,null,null,null,0,null,"Functional"]
[null,"SYS73","I","W",null,null,null,null,0,null,"Functional"]
[null,"SYS74","I","W",null,null,null,null,0,null,"Functional"]
[null,"SYS75","I","W",null,null,null,null,0,null,"Functional"]
[null,"SYS76","I","W",null,null,null,null,0,null,"Functional"]
[null,"SYS77","I","W",null,null,null,null,0,null,"Functional"]
[null,"SYS78","I","W",null,null,null,null,0,null,"Functional"]
[null,"SYS79","I","W",null,null,null,null,0,null,"Functional"]
[null,"SYS80","I","W",null,null,null,null,0,null,"Functional"]
[null,"SYS81","I","W",null,null,null,null,0,null,"Functional"]
[null,"SYS82","I","W",null,null,null,null,0,null,"Functional"]
[null,"SYS83","I","W",null,null,null,null,0,null,"Functional"]
[null,"SYS84","I","W",null,null,null,null,0,null,"Functional"]

{"sheet":"Metrics","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Stakeholders","index":2,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[[0,0,0,13]]}
["Stakeholders"]

{"sheet":"Notes","index":3,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
["Item Number","Notes"]

{"sheet":"Acronyms","index":4,"n_rows":1,"n_cols":2,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Acronym","Description"]